BEGIN TRANSACTION ALTER TABLE dbo.data_SalesInfo ADD BrokerID smallint NULL GO COMMIT BEGIN TRANSACTION ALTER TABLE dbo.gen_Appconfig ADD BrokeryAccount int NULL, BhrtiAccount int NULL, LoadingAccount int NULL, SvKrayaAccount int NULL GO COMMIT